﻿USE [ShopDB]
GO

/****** Object:  StoredProcedure [dbo].[BasketDeleteProduct]    Script Date: 04/07/2011 21:06:24 ******/
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BasketDeleteProduct]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[BasketDeleteProduct]
GO

USE [ShopDB]
GO

/****** Object:  StoredProcedure [dbo].[BasketDeleteProduct]    Script Date: 04/07/2011 21:06:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		Alexander Litvinenko
-- Create date: 2011
-- Description:	Delete product from basket
-- =============================================
CREATE PROCEDURE [dbo].[BasketDeleteProduct] 
	@UserName nvarchar(256),
	@ProductID bigint
AS
BEGIN
	DELETE FROM Baskets WHERE UserName = @UserName AND ProductID = @ProductID
END

GO


